Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# $ALLOCMAP

The $ALLOCMAP property specifies the default aggmap for allocation for a variable. This is the aggmap that Oracle OLAP uses when the variable is the target variable of an ALLOCATE statement that does not include a USING phrase.

Syntax

You add or delete an $ALLOCMAP property to the most recently defined or considered object (see DEFINE and CONSIDER) using a PROPERTY statement:

- To add the property, issue the following statement.

  PROPERTY '$ALLOCMAP' aggmap-name

- To delete the property, issue the following statement.

  PROPERTY DELETE '$AALLOCMAP'

Arguments

aggmap-name

  A `TEXT` expression that specifies the name of a previously defined ALLOCMAP type aggmap object.

Examples

Example 6-4 Using $ALLOCMAP to Specify a Default Allocation Specification

Example 7-17, "Recursive Even Allocation with a Lock" uses the following statement to allocated data in the `projbudget` variable using the `projbudgmap` allocation specification.

    ALLOCATE projbudget USING projbudgmap

You can specify that `projbudgmap` is the default allocation specification for the `projbudget` variable by issuing the following statements.

    CONSIDER projbudget
    PROPERTY ('$ALLOCMAP' "projbugmap')

Now, merely by issuing the following statement, you can allocate data in the `projbudget` variable using the `projbudgmap` allocation specification.

    ALLOCATE projbudget